package com.beone.smart.smartBeauty.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.beone.smart.smartBeauty.model.entity.ProductGatherDO;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.HashMap;
import java.util.List;

@Repository
public interface ProductGatherDao extends BaseMapper<ProductGatherDO> {
    @Select("SELECT productCode,productName,count(productName) as mount  from product_gather GROUP BY productCode,productName ORDER BY mount desc")
    List<HashMap<String, String>> getList();
}
